package com.im.app.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.im.app.model.VisitorAvatar;
import org.apache.ibatis.annotations.Select;

public interface VisitorAvatarMapper extends BaseMapper<VisitorAvatar> {

    @Select("SELECT * from visitor_avatar WHERE u_count = (SELECT MIN(u_count) FROM visitor_avatar) limit 1")
    VisitorAvatar getVisitorAvatarByRandom();
}
